Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a string which is like
1.1 deposits
when I use the below code
SubField((SubField([Line Description],' ', 1)), '.', 1) as LEVEL1
the output of 1.1 deposits should be 1. However, it is not working. How do I make this work? thanks
Hi,
You dont need 1 Deposits ..?
Please explain the logic in details.
Regards,
Kaushik Solanki
From the above what is your expected output?
Basically I would like to just extract the first digit before the first decimal point. So if the string is "5.6 Assets", I would like the value 5. If the string is "12.44.7 Liability", I would want 12.
I have a string which is like
1.1 deposits
2.1 assets
55.1 liability
my expected output will be
1
2
55
Why can't you simply try with..
SubField('12.44.7 Liability','.', 1)
Try with..
SubField([Field name],'.', 1)
AFAIK your original code works like a charm. Are you sure about the actual content of field [Line Description] ?
Note: to make sure that I use the same code as you did, I copy/pasted your script line into the editor.
Of course, surendra j already posted a shorter version that produces the same output.
Please Close the thread..if you got the relevant one..
It will be useful to community members.