Changing and adding punctuation in a split macro?
Hello,
I have a macro / module that splits names of a folder into different columns in excel. What I am wondering is if my folder looks like this FRANK^JOE_12341234_19120304 is there a way to get excel to change this ^ to a comma ,or would it be easier to have the name split on the ^? If having the split on the ^ is better how would i add that into my current macro / module? If I need to post the macro i can.
Thank You
Last edited by dark91zc; 08-02-2013 at 05:10 PM.
Please do..
Here is the macro
Please Login or Register to view this content.
I don't think a ^ is allowed in a foldername.
I am running Windows 7 32-bit, and the program i am using output the folder names like this. Thank you.
My guess.
Change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
If I did that would it only split on the ^ or would it still split on the _ ? Sorry I am new to this and trying to learn as i go along for work. Also how do i get it to not split on a Space? Thank you and sorry.
How do you want it?
Can you show me the folder name and the result that you want?
the folders look like this
DOE^JOHN_12349876_19450125
SUE^JEFF_95157535_19181221
SMITH^LEE_84269713_19631124
In Excel
Column A will be the persons last name
Column B will be the persons first name
Column C will be the first 8 numbers (MDR)
Column D will be the last 8 numbers (Date of Birth)
Please Login or Register to view this content.
I just replace my cell 1
With yours correct?Please Login or Register to view this content.
ThanksPlease Login or Register to view this content.
Please Login or Register to view this content.
Hello Jindon
i had tried that and got an error i will find out today.
I just ran the code again and it does not even split the folder names it just puts them in one column.
this is what it looks like
LEE^CHUE^00343918^19451201
JANE^MARY^00560803^19430222
after running the code
those 4 elements need to be in their own column. but i need to split on the ^ sign as well as the _ sign.
so column a is the last name
column b is the first name
column c is the mdr
column d is the birthdate
last name first name mdr date of birth lee chue 00343918 19451201 JANE MARY 00560803 19430222
thanks
Last edited by dark91zc; 08-01-2013 at 11:06 AM.
Ahh
missed delimiter
Please Login or Register to view this content.
Sweet thank you =D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks