Let me explain with reference to my previos message.
I have 2 tables in database 1 have cNo feild & 2 have cName feild,
I have to make pair from these 2 tables.
Now, what i thought to carry out this,
using foreach loop on cNo and getting cName feild from 2nd table.
Now i have both cNo & cName feild
then make 3rd table using both these cNo, cName feild.(Need a bit suggection here, as i will make this thru code(not creating this in DB) so can i perform operation on this table)
After that making pair of common entries,
But How to make pair??
The way i am using is correct?
Need some advice How to do this?
Why do you need regex for that?
I would do it 'by hand':
- remove spaces (if any) with string.Replace(" ", "")
- foreach character in the string, if it is numeric, append it to the numeric part, else append it to the letter part