Is there a way to break this up into items? I have a table that values get entered. The user is basically entering each item on one line (cell). I am asking can i break these up? Soโฆ if you look at the example, each new item begins after the comma โ,โ. Can i have an expression that looks at everything after a comma โ,โ as a new item?
(1) [000000325] 2013 16โ LOWBOY TRAILER - VIN # 17XFH1627D1035912 - PLATE # 270758H,(1) [000050515] 4,000 PSI HOT WATER PRESSURE WASHER SKID ENGINE SERIAL NUMBER MISSING
You might check out SPLIT()
will do.
Thanks
i have a question. Can the First section of Split (some text, Delimiter) be the column?
Like this?
<<SPLIT(โ[Item_List]โ, โ,โ)>>
SPLIT([Item_List],โ,โ) would be enough.
If this is on my template - using for reporting - do i need the <<>>?
Correct
ok. Thanks let me try thisโฆ
Ok. It did not separate them into separated rows:
I need that paragraph i circled separated into rows based on that comma โ,โ
I am trying to basically itemize this. So the paragraph i circled should separate each item out and show them individually (by a row). I will also need that โQtyโ beside the paragraph i circled showing the quantity based on the paragraph items:
(2) 10 K Hydroโฆ - i would need the Qty to show - โ2โ
I have added to the expression which is working better - but i need this to NOT force me to decide how many items to index - because i will never know how many the user will enter. I want to start a โStartโ expression - but i didnt get it right - gave me errorsโฆ
I used this for the โDescriptionโ column:<<Index(SPLIT([Item_List],โ,โ),1)>>
I used this for the โqtyโ column: <<LEFT(Index(SPLIT([Item_List],โ,โ),1), 3)>>
Here is the raw data table (snipped picture):
In this picture, i will also need to figure out how to get those items in [ ] to show up in my template under โItemโโฆ
SPLIT() turns a text string into a list. However, if you tell app to just print the list, it basically just concatenates the values of the list back together.
A Start expression (I think, but not sure) needs to be Key values to work. It would be way easier, if those line items were instead stored in a child table with their own unique IDs so that you could easily use the Start expression. Otherwise, I think with your data the way it is, youโre stuck hardcoding the template the way you already started.
yeah unfortunately - the way the software works now that my company uses to create a dispatch ticket - you see the picture above - the items are ALL listed in that โItem_Listโ cellโฆ
Try:
SUBSTITUTE([Item_List], ",", "
")
Note that the expression itself is two lines. Thatโs critical!
ok. Thanks - let me try thisโฆ
Ooo, smart idea. Iโve used similar things in the past. Might work in this case.
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |