Multi value

Multi-Value

Consider the following example:

• We have 2 customers: John Doe and Mary Rose
• John has 3 phone numbers:
  • MTN Rwanda: 0788000000 and 0788111111
  • Airtel Rwanda:0739000000
• Mary has only 1 phone number:
  • Orange Luxembourg: 661890943

This is how we can represent these details:

'John Doe':@VM:'MTN Rwanda':@SM:'0788000000':@SM:'0788111111':@VM:'Airtel Rwanda':@SM:'0739000000':@FM:'Mary Rose':@VM:'Orange Luxembourg':@SM:'661890943'

• We have one field for "Mobile Network Operator" which can have multiple values separated by @VM (Value Mark)
• We have one field for "Phone number" denoted by @SM (Sub-Value Mark)
• Here names are Single Field. The delimer is @FM or @AM (Field Mark)