emi_sastra
asked on
FORMULA TO SEPARATE DATA
Hi All,
I have a column with data :
'Lembur@171.00 Jam x@'
I want to separate it into 2 formula :
1. fmlDesc = 'Lembur'
2. fmlQty = '171.00 Jam x'
How could I do it ?
Thank you.
I have a column with data :
'Lembur@171.00 Jam x@'
I want to separate it into 2 formula :
1. fmlDesc = 'Lembur'
2. fmlQty = '171.00 Jam x'
How could I do it ?
Thank you.
ASKER
Hi mlmcc,
Let me try first.
Thank you.
Let me try first.
Thank you.
ASKER
Hi mlmcc,
Some the data has no @.
What should I do ?
Thank you.
Some the data has no @.
What should I do ?
Thank you.
What does it mean when there is no "@"?
Do you not want to use that string at all?
--or--
Do you want to use the whole string as one thing or the other (fmlDesc or fmlQty)? Which one? And then just leave the other part blank?
--or--
Do you still want to split the string, but using some other character (not "@") as the delimiter?
James
Do you not want to use that string at all?
--or--
Do you want to use the whole string as one thing or the other (fmlDesc or fmlQty)? Which one? And then just leave the other part blank?
--or--
Do you still want to split the string, but using some other character (not "@") as the delimiter?
James
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great.
Thank you very much for your help.
Thank you very much for your help.
fmlDesc
Split({YourField},"@")[1]
fmlQty
Split({YourField},"@")[2]
mlmcc