Forum Discussion
Creating a table listing of records where a client code appears in the Title text string
Select By Delimiter > Custom > Comma. Expand the Advanced Options button and select Rows. Click on OK.
Super UserHi,
In the Records Table, use the Query Editor to split "Description of Contents" column by rows.
Hi Ashish,
I'm sorry, but I don't entirely understand. In Query Editor under the Transform tab and the Text Column group, I have the following options to "Split Column":
By Delimiter
By Number of Characters
By Positions
By Lowercase to Uppercase
By Uppercase to Lowercase
By Digit to Non-Digit
By Non-Digit to Digit
Which one of the above is split column by rows?
I may not have explained myself properly....
The actual "Description of Contents" field varies in length and format - all I can notice is that one or more Client codes appear within this field in no consistent manner.
Is it possible to use the Client table as a variable/parameter (not sure which) to search in the "Description of Contents" field for that client code and then record (somewhere) the corresponding record number that it appears within. Sorry if I didn't make that clearer before.
The actual file I need to apply this to has thousands of rows to search through and there are multiple client codes to search for. I just made up a simple example with a few dummy client codes and record numbers.
I hope that makes it a little clearer of what I am trying to do.
Appreciate your help!
- Ashish_Mathur
Select By Delimiter > Custom > Comma. Expand the Advanced Options button and select Rows. Click on OK.
Excellent - Thankyou! That worked well - much appreciated 😀
- Ashish_Mathur
You are welcome.