Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Copying part of a string after instance of a character

Pretty simple. As an example:

.\Archive(20140114) G2-253_G2-252 (Upstream)(20140114) G2-253_G2-252 (Upstream).mpg

Needs to JUST become: (20140114) G2-253_G2-252 (Upstream).mpg in a different column

Problem : The amount of characters in a string can vary, and is not static.

What I want: I can put thousands of the first example in column A. I want column B to just show everything after the third '\'. Is there a code that will put everything after the third '\' into column B.

Copying part of a string after instance of a character

Pretty simple. As an example:

.\Archive(20140114) .\Archive\(20140114) G2-253_G2-252 (Upstream)(20140114) (Upstream)\(20140114) G2-253_G2-252 (Upstream).mpg

Needs to JUST become: (20140114) G2-253_G2-252 (Upstream).mpg in a different column

Problem : The amount of characters in a string can vary, and is not static.

What I want: I can put thousands of the first example in column A. I want column B to just show everything after the third '\'. Is there a code that will put everything after the third '\' into column B.

Copying part of a string after instance of a character

Pretty simple. As an example:

.\Archive\(20140114) G2-253_G2-252 (Upstream)\(20140114) G2-253_G2-252 (Upstream).mpg

Needs to JUST become: (20140114) G2-253_G2-252 (Upstream).mpg in a different column

Problem : The amount of characters in a string can vary, and is not static.

What I want: I can put thousands of the first example in column A. I want column B to just show everything after the third '\'. Is there a code that will put everything after the third '\' into column B.B?

Copying part of a string after instance of a character

Pretty simple. As an example:

.\Archive\(20140114) G2-253_G2-252 (Upstream)\(20140114) G2-253_G2-252 (Upstream).mpg

Needs to JUST become: (20140114) G2-253_G2-252 (Upstream).mpg in a different column

Problem : The amount of characters in a string can vary, and is not static.

What I want: I can put thousands of the first example in column A. I want column B to just show everything after the third '\'. Is there a code that will put everything after the third '\' into column B?