Forum Discussion
ScottRobertson
Qrew Trainee
Appreciate the input!
The other issue I failed to mention is that the length of that field can range from 1 delimiter to 50,000+... would I need to complete 50,000 "trims" with this solution?
------------------------------
Scott Robertson
------------------------------
The other issue I failed to mention is that the length of that field can range from 1 delimiter to 50,000+... would I need to complete 50,000 "trims" with this solution?
Trim(Part($value,1,";"))<>"",
Trim(Part($value,2,";"))<>"",
Trim(Part($value,3,";"))<>"",
…
Trim(Part($value,50000,";"))<>"",
------------------------------
Scott Robertson
------------------------------
DonLarson
5 years agoQrew Commander
Scott,
If you have an external data source with the delimited text, you should transform the data before writing to Quick Base. What ever code you are using to extract from the other DB and load to Quick Base is undoubtedly more powerful than the formula fields in Quick Base. Quick Base is great but is deliberately kept simple for the Citizen Builder to be able to make business process applications for users.
Your case above is outside the box for Quick Base but not that difficult with a Loop in your external code. Then you can add a second field in Quick Base that is the Count of Delimiters as a Numeric field instead of a Formula Numeric.
I assume with the text field and numeric field you can then get on to the business case for why you wanted to import the data to begin with.
Good luck and happy building.
Don
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
If you have an external data source with the delimited text, you should transform the data before writing to Quick Base. What ever code you are using to extract from the other DB and load to Quick Base is undoubtedly more powerful than the formula fields in Quick Base. Quick Base is great but is deliberately kept simple for the Citizen Builder to be able to make business process applications for users.
Your case above is outside the box for Quick Base but not that difficult with a Loop in your external code. Then you can add a second field in Quick Base that is the Count of Delimiters as a Numeric field instead of a Formula Numeric.
I assume with the text field and numeric field you can then get on to the business case for why you wanted to import the data to begin with.
Good luck and happy building.
Don
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------