Any Kind Soul willing to help? How to convert data saved in TEXT file into a table form. PLS HELP !!!!!

Question

Any Kind Soul willing to help? I am currently having a string of data and i wanted to convert them into a table form. The string is in this way N00000S1P30 and i wanted to split it into

Parts number
00000

Value
1st spin 30.0

Can anyone kindly guide me through? Thank you so much!!!!

brunda k · Answer

it is for the query part i wanted to split it into. details about the table was not provided. Assumptions: all the strings will be in format N PartNumber S Spin Number P Decimal Digit

brunda k · Answer

string input = N00000S1P30; Match match = Regex.Match(input @N([0-9]+)S([0-9]+)P([0-9]+([\.][0-9]{13})?$) RegexOptions.IgnoreCase); if (match.Success) { StringBuilder sb = new StringBuilder(); sb.Append(Parts Number 
); sb.Append(match.Groups[1].Value.ToString()+
); sb.Append(Value 
); sb.Append(match.Groups[2].Value.ToString() + st spin + ((match.Groups[3].Value.ToString().Contains(.)) ? (match.Groups[3].Value.ToString()) : match.Groups[3].Value.ToString() + .0)); Console.WriteLine(sb.ToString()); } Thankyou!

Leung JiaJun Randson · Answer

Dearest bruda Good morning bruda I have a total of 6 keywords ( N Q T L A S) N= Part number Q= Data identifier ( 1: Parameter data 0: Pitch error compensation data) T= Machine Group ( example: T1=10000001) = (1st machine group:bit 0 and 7 set to 1 and other bit is set to 0) (T2=00000001) = (2nd machine group: bit 0 set to 1 and other bit are set to 0) L= Path Number (example: L1= path1 L2= path 2 etc etc) A= Axis (example: A1= 1st Axis A2=2ndAxis) S= spin ( example: S1= 1st spin S2= 2nd Spin) Example: N00000Q1L1P88T1A1S1P110000001 = Part: 00000 Path1:88 1st machine group: bit 0 and bit 7 set to 1 others set to 0 1st axis:bit 0 and bit 7 set to 1 others set to 0 1st spin:bit 0 and bit 7 set to 1 others set to 0 Bruda Pls help. Thank you so much. Appreciated.. Thank you very very much

Leung JiaJun Randson · Answer

Dearest Brunda K Thank you so much. But it appear telling me N([0-9]+S([0-9]+)P([0-9]+([\.][0-9]{13})?$) -Not Enough)'s What is the meaning ????