AnsweredAssumed Answered

How can I break out this info?

Question asked by Kirk_1 on Oct 24, 2014
Latest reply on Oct 24, 2014 by Kirk_1

Title

How can I break out this info?

Post

 ID83713 

800-525-7400000-000-0000208-863-3064NA        

 

This is in a .txt file. I'm going to import it into FM. Is there a way to break out the info before i import it or do i have to run a script in FM after and parse it out that way?

The state and zip are combined there is a space then the phone numbers.

This is what i want to try to import.                              

State:: ID     ZipCode:: 83686     PhoneNumber:: 208-863-3064

                                                                        

Outcomes