Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In chart expression i am trying to concat mutiple code with alpha numeric like 123.4, A12.1 and 1234SD.45. In this i have another condition i.e After Concatenating all the code the length should not exceed 100 characters, if it is exceeding more than 100 that should be written in separate .
Please help me from this situation .
Can you give an eg with your expected output for that value?
Hi ,
I have data like this
Claims | Code1 | Code2 | Code3 | Code4 | Code5 | Code6 |
ABC | 12.A | |||||
SDS | 12.34 | 212.56 | 21F.45 | X123.456 | ||
FGG | 212.45 | 212.11 | ||||
HUR | 21.345 | 12.78 | ||||
HIT | 754.09 | 564D.89 | ||||
SDE | 89U.76 |
1. Now I need to CONCAT all the codes in to 1 field and remove the extra commas where data is not there.
2. All the field length should be 100, it is crossing 100 means then i need to write in a separate field.
Ex: After Concatenating all the fields , if my field lenth is 110 means
Code1 should have 100 and Code2 shold have that 10 fields data.
Now i want to remove commas in fieldss where there is no data ?
How to break the field when that has 100 field length and write to next field ?
Hi,
Try something like:
=if(len(SubField(Description,'.',2))<=100, Description,Expression)