• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

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.
0
emi_sastra
Asked:
emi_sastra
  • 3
  • 2
1 Solution
 
mlmccCommented:
Try this

fmlDesc
Split({YourField},"@")[1]

fmlQty
Split({YourField},"@")[2]

mlmcc
0
 
emi_sastraAuthor Commented:
Hi  mlmcc,

Let me try first.

Thank you.
0
 
emi_sastraAuthor Commented:
Hi  mlmcc,

Some the data has no @.

What should I do  ?

Thank you.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
James0628Commented:
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
0
 
mlmccCommented:
If there are no @ there will only be 1 string

You can try this

fmlDesc
Split({YourField},"@")[1]

fmlQty
Local StringVar Array arrStrings;

arrStrings := Split({YourField},"@");
If UBound(arrStrings) >= 2 then
    arrStrings[2]
Else
    "No fmlQty"

mlmcc
0
 
emi_sastraAuthor Commented:
Great.

Thank you very much for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now