djvillarreal
New Member
- Joined
- Nov 29, 2015
- Messages
- 1
Hello, just recently joined and this is my first post.
The problem I have is this:
A cell would contain several formats like...
"KAT LI 927000000403G LINS" and I need to extract "927000000403G"
"KAT LI AA432IPXTV00HB (LINS) Alt 2" and need "AA432IPXTV00HB"
"KAT LI ICE-8S10 (LINS)" and need "ICE-8S10"
"KAT TCRA RET475N73M LINS" and need "RET475N73M"
"MB KAT LI IML70RLFM (LINS)" and need "IML70RLFM"
"LMT KAT AOT6P82HL90BN(4C kliye) LINS ALT2" and need "AOT6P82HL90BN"
"ULT KAT LI BI189C135T140VSF1M LINS" and need "BI189C135T140VSF1M"
"TB KAT LMT IMR67KLRM (TEBLOW B SIDE)" and need "IMR67KLRM"
The text needed is actually a product part number that then I will need to Vlookup for a forecast in a separate file. The forecast file has the product part number as reference.
I included all these examples to show the differing formats of the cells.
The list I'm working on contains over 400 rows with this type of format and was generated in a SAP production system. The problem is I will be working with this kind of files more often so I need I way to optimize the process, hopefully you can help. I already asked for the file in a cleaner format but it seems SAP is not very flexible when it comes to this reports.
My initial idea was to find a way to extract the text between the first two-three spaces found and stop after the next space is found (don't know how to do it) but I will have to separate the cells that contain 2 and 3 spaces before the text I need, not optimal but I can prep the file for this.
Hopefully there is a better way to solve this problem.
Kind Regards.
Daniel
The problem I have is this:
A cell would contain several formats like...
"KAT LI 927000000403G LINS" and I need to extract "927000000403G"
"KAT LI AA432IPXTV00HB (LINS) Alt 2" and need "AA432IPXTV00HB"
"KAT LI ICE-8S10 (LINS)" and need "ICE-8S10"
"KAT TCRA RET475N73M LINS" and need "RET475N73M"
"MB KAT LI IML70RLFM (LINS)" and need "IML70RLFM"
"LMT KAT AOT6P82HL90BN(4C kliye) LINS ALT2" and need "AOT6P82HL90BN"
"ULT KAT LI BI189C135T140VSF1M LINS" and need "BI189C135T140VSF1M"
"TB KAT LMT IMR67KLRM (TEBLOW B SIDE)" and need "IMR67KLRM"
The text needed is actually a product part number that then I will need to Vlookup for a forecast in a separate file. The forecast file has the product part number as reference.
I included all these examples to show the differing formats of the cells.
The list I'm working on contains over 400 rows with this type of format and was generated in a SAP production system. The problem is I will be working with this kind of files more often so I need I way to optimize the process, hopefully you can help. I already asked for the file in a cleaner format but it seems SAP is not very flexible when it comes to this reports.
My initial idea was to find a way to extract the text between the first two-three spaces found and stop after the next space is found (don't know how to do it) but I will have to separate the cells that contain 2 and 3 spaces before the text I need, not optimal but I can prep the file for this.
Hopefully there is a better way to solve this problem.
Kind Regards.
Daniel
