Splitting a LONG Column

[JWGoldfinch]

I have split columns before using the (LEFT,RIGHT,MID) statements after finding a character, but this is my challenge. I have a column that has multiple "\" characters in variable positions and all the text between them and the last characters after the last "\" needs to be in separate fields. Here is an example of some of the data In that column:[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]\SERVER\PARTS\COUNTER[/TD]
[/TR]
[TR]
[TD]\CLIENT SERVER\SERVICE\WORK ORDERS\ENTW300[/TD]
[/TR]
[TR]
[TD]\RENTAL LEASING\CONTRACTS\ENT300[/TD]
[/TR]
</tbody>[/TABLE]

 

[VoG]

Try Data > Text to Columns > Delimited with \ as the delimiter.

 

[JWGoldfinch]

Thanks, did not even think of this and I have used this feature before. I guess I'm getting older than I thought, the mind is going. Thanks Again